﻿# SQL Manager Lite for MySQL 5.3.1.7
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : flx_qcubed


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

SET FOREIGN_KEY_CHECKS=0;

USE flx_qcubed;

#
# Data for the contact table  (LIMIT -498,500)
#

INSERT INTO contact (id, street, state, city, zipcode, notes, google_maps_url, flickr_url, facebook_url, twitter_url, skype_url, msn_url, google_plus_url, log_user, log_insert, log_update) VALUES

  (1,'A. Malaver 4436','Buenos Aires','Florida','1602','Lunes a viernes de 08:00 a 12:00 y de 15:00 a 20:00 h.\nSábados de 08:00 a 13:00 h.','https://www.google.com/maps?t=m&amp;q=Antonio+Malaver+4436,+Munro,+Buenos+Aires+Province,+Argentina&amp;ie=UTF8&amp;hq=&amp;hnear=Antonio+Malaver+4436,+Munro,+Buenos+Aires,+Argentina&amp;ll=-34.527561,-58.522196&amp;spn=0.024749,0.081539&amp;z=14&amp;iwloc=A&amp;output=embed','','','','','','','jmirancid',NULL,'2013-11-15 10:01:40');
COMMIT;

#
# Data for the contact_email table  (LIMIT -497,500)
#

INSERT INTO contact_email (id, contact_id, email, log_user, log_insert, log_update) VALUES

  (1,1,'laquear1@hotmail.com','jmirancid',NULL,'2013-11-30 01:16:35'),
  (2,1,'proyecto-decoracion@hotmail.com','jmirancid',NULL,'2013-09-25 00:48:30');
COMMIT;

#
# Data for the contact_phone table  (LIMIT -496,500)
#

INSERT INTO contact_phone (id, contact_id, number, log_user, log_insert, log_update) VALUES

  (1,1,'(011) 4761-0682','jmirancid',NULL,'2013-09-25 09:59:10'),
  (2,1,'(011) 15 5004-3345','jmirancid',NULL,'2013-09-25 09:58:40'),
  (3,1,'(011) 15 3350-1945',NULL,NULL,'2013-09-01 23:56:48');
COMMIT;

#
# Data for the content_key table  (LIMIT -460,500)
#

INSERT INTO content_key (id, content_page_type_id, name, value, content_key_type_id, log_user, log_insert, log_update) VALUES

  (1,1,'link_about_title','The Very Best',1,'jmirancid','2013-08-23 00:06:30','2014-04-02 11:52:18'),
  (2,1,'link_about_subtitle','Ideas For You',1,'init','2013-08-23 02:11:21','2014-04-02 11:52:20'),
  (3,1,'link_about_summary','Nearuasi architeto beataecusa ntium reuede vitaeiciat keruaser.',1,'init','2013-08-23 00:07:11','2014-04-02 11:52:20'),
  (4,1,'link_project_tile','Eco',1,'init','2013-08-23 00:07:48','2014-04-02 11:52:21'),
  (5,1,'link_project_subtitle','Materials',1,'init','2013-08-23 02:11:53','2014-04-02 11:52:22'),
  (6,1,'link_project_summary','Architecto beatae naseaerspa madryt sysea ciat keruiase rlertyuad.',1,'init','2013-08-23 00:08:20','2014-04-02 11:52:23'),
  (7,1,'welcome_title','Bienvenidos !',1,'jmirancid','2013-08-23 00:09:21','2014-04-02 11:52:24'),
  (8,1,'welcome_summary','Sed a volutpat orci. Nunc vestibulum nisl in sem ullamcorper aliquam. Suspendisse accumsan nisi neque, vitae consectetur nisl scelerisque vel.',3,'jmirancid','2013-08-23 00:10:38','2014-05-14 17:03:19'),
  (9,1,'link_service_title','Tallados',1,'init','0000-00-00 00:00:00','2014-04-02 12:20:17'),
  (10,1,'link_service_subtitle','Y Pintura',1,'init','0000-00-00 00:00:00','2014-04-02 12:20:19'),
  (11,1,'link_service_summary','Architecto beatae nasea madrsysea\r\nmiatkeruiase rlertyuad unde omasler siase\r\nlerosac cusa ntiuede earste.',1,'init','0000-00-00 00:00:00','2014-04-02 12:20:21'),
  (12,1,'welcome_message','Lo invitamos a conocer nuestras amplia gama de trabajos y servicios en diseñados sobre maderas de primerísima calidad para realzar el buen gusto de su hogar u oficina. a partir de nuestros clásicos diseños totalmente realizados de manera arteseanal y profesional.',2,'init','0000-00-00 00:00:00','2014-05-14 17:03:17'),
  (13,1,'follow_title','Social',1,'init','0000-00-00 00:00:00','2014-05-14 17:05:53'),
  (14,1,'follow_message','Nulla duiuscat maluada odior nucoidase na magnonec accumsauada:',3,'init','0000-00-00 00:00:00','2014-05-14 17:02:53'),
  (15,1,'news_title','¿ Sabias Qué ?',1,'init','0000-00-00 00:00:00','2014-04-02 12:20:27'),
  (16,1,'news_message','<b>Bibulum molestie lacueno mera</b>\nyhe ndrerit mauris ketyadasellus porta. Fusce suscipit vari usiasera um socieras natoque ades kertyade miasera.\n<b>Naserenatibus et magnrturt montesera nascetur ridimus neryasuluierytase.</b>',3,'init','0000-00-00 00:00:00','2014-05-14 17:04:13'),
  (500,5,'main_title','Conocenos',1,'init','2013-08-28 09:44:37','2014-05-14 15:18:54'),
  (501,5,'main_submessage','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Praesent vestibulum molestie lacus. Aenean nonummy hendrerit mauris. Phasellus porta.',1,'init','2013-08-28 09:46:57','2014-04-02 12:18:28'),
  (502,5,'main_message','Fusce feugiat <b>malesuada odio</b>. Morbi nunc odio, gravida at, cursus nec, luctus a, lore. Maecenas tristique orci ac sem. Duis ultricies pharetra magna. Donec accumsan malesuada orci. Donec sit amet eros. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Mauris fermentum dictum magna. Sed laoreet aliquam leo. Ut tellus dolor, dapibus eget, Integer rutrum ante eu lacus. Lorem ipsum dolor sit amet, consectetuer adipiscing elit.',3,'init','2013-08-28 09:48:08','2014-05-14 15:21:00'),
  (503,5,'our_values_title','Our Values Principles',1,'init','2013-08-28 09:49:05','2014-04-02 12:18:32'),
  (504,5,'our_values_message','Lorem ipsum merch.',1,'init','2013-08-28 09:50:08','2014-04-02 12:18:33'),
  (505,5,'our_pledge_title','Nuestras Marcas',1,'init','2013-08-28 09:50:46','2014-05-14 15:52:09'),
  (506,5,'our_pledge_subtitle','Only highly qualified and motivated staff',1,'init','2013-08-28 09:51:59','2014-04-02 12:18:38'),
  (507,5,'our_pledge_message','Morbi nunc odio, gravida at, cursus nec, luctus a, lore. Maecenas tristique orci ac sem. Duis ultricies <b>pharetra magna. Donec accumsan malesuada orci. Donec sit amet eros. Lorem ipsum dolor sit amet</b>, consectetuer adipiscing elit. Mauris fermentum dictum magna. Sed laoreet aliquam leo. Ut tellus dolor, dapibus eget, Integer rut<u>rum ante eu lacus. Praesent vestibulum molestie lacus.</u>',3,'init','2013-08-28 09:52:51','2014-05-14 15:52:33'),
  (508,5,'our_team_title','Our Team',1,'init','2013-08-28 09:54:03','2014-04-02 12:18:41'),
  (509,5,'our_team_member_one_name','Jhon Franklin',1,'init','2013-08-28 09:54:39','2014-04-02 12:18:43'),
  (510,5,'our_team_member_one_bio','Basnim ipsam lertase volupta jertyades.',1,'init','2013-08-28 09:55:15','2014-04-02 12:18:45'),
  (511,5,'our_team_member_two_name','Inga North',1,'init','2013-08-28 09:56:10','2014-04-02 12:18:50'),
  (512,5,'our_team_member_two_bio','Basnim ipsam lertase volupta jertyades.',1,'init','2013-08-28 09:56:35','2014-04-02 12:19:00'),
  (513,5,'our_team_member_three_name','Patrick Pool',1,'init','2013-08-28 09:57:02','2014-04-02 12:19:02'),
  (514,5,'our_team_member_three_bio','Basnim ipsam lertase volupta jertyades.',1,'init','2013-08-28 09:57:46','2014-04-02 12:19:05'),
  (515,5,'news_title','Lastets News',1,'init','2013-08-28 09:58:14','2014-04-02 12:19:08'),
  (516,5,'feedback_title','Our Clients Say',1,'init','2013-08-28 09:58:40','2014-04-02 12:19:31'),
  (517,5,'feedback_comment_one_message','Morbi nunc odio, gravida at, cursus nec, luctus a, lorem. Maecenas tristique orci acsem duis ultricies pharetra magna donec accumsan...',3,'init','2013-08-28 09:59:22','2014-05-14 15:22:56'),
  (518,5,'feedback_comment_one_author','John Anderson',1,'init','2013-08-28 10:00:30','2014-04-02 12:19:36'),
  (600,6,'main_title','How To Find Us',1,'init','2013-09-02 00:49:47','2014-04-02 12:20:56'),
  (601,6,'main_message','Fusce euismod <b>consequat </b>ante. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Pellentesque sed dolor. Aliquam congue fermentum nisl. Mauris accumsan nulla vel diam. Sed in <u>lacus </u>ut enim adipiscing aliquet. Nulla <b>venenatis. In pede mi, aliquet </b>sit amet, euismod.',3,'jmirancid','2013-09-02 00:50:05','2014-05-14 16:27:17'),
  (602,1,'service_title','Servicios',1,'init','0000-00-00 00:00:00','0000-00-00 00:00:00'),
  (603,1,'project_title','Últimos Proyectos',1,'init','0000-00-00 00:00:00','2014-05-14 16:56:48');
COMMIT;

#
# Data for the content_key_type table  (LIMIT -496,500)
#

INSERT INTO content_key_type (id, name) VALUES

  (1,'SingleText'),
  (2,'MultiText'),
  (3,'RichText');
COMMIT;

#
# Data for the content_page table  (LIMIT -491,500)
#

INSERT INTO content_page (content_page_type_id, url) VALUES

  (1,'/php/home'),
  (2,'/php/project'),
  (3,'/php/service'),
  (4,'/php/company'),
  (5,'/php/about'),
  (6,'/php/contact'),
  (7,'/php/privacy'),
  (8,'/php/legal');
COMMIT;

#
# Data for the content_page_type table  (LIMIT -491,500)
#

INSERT INTO content_page_type (id, name) VALUES

  (1,'Home'),
  (2,'Projects'),
  (3,'Services'),
  (4,'Company Profile'),
  (5,'About'),
  (6,'Contact'),
  (7,'Privacy Policy'),
  (8,'Legal');
COMMIT;

#
# Data for the setting table  (LIMIT -483,500)
#

INSERT INTO setting (id, key, value, description, log_user, log_insert, log_update) VALUES

  (1,'email_server_name','ssl://smtp.gmail.com','Email Server Hostname','_init','0000-00-00 00:00:00','2013-10-08 01:45:17'),
  (2,'email_server_port','465','Email Server Port','_init','0000-00-00 00:00:00','2013-10-08 01:45:18'),
  (3,'email_server_user','nortatum@gmail.com','Email Server Account Username','_init','0000-00-00 00:00:00','2013-10-08 01:45:19'),
  (4,'email_server_pass','Pa$$word001','Email Server Account Password','_init','0000-00-00 00:00:00','2013-10-08 01:45:19'),
  (5,'email_server_test','c:/temp/','Email Server Test Queue Path','_init','0000-00-00 00:00:00','2013-10-08 01:45:20'),
  (6,'cloudinary_cloudname','dl05ea4pe','Cloudinary Storage Service Cloud Name','_init','0000-00-00 00:00:00','2013-10-08 01:45:20'),
  (7,'cloudinary_api_key','645385234334422','Cloudinary Storage Service API Key','_init','0000-00-00 00:00:00','2013-10-08 01:45:21'),
  (8,'cloudinary_secret','KkGn52w1Qc4XKwGtTtlmH1pPkt0','Cloudinary Storage Service API Secret','_init','0000-00-00 00:00:00','2013-10-08 01:45:21'),
  (9,'portrait_width','540','Portrait Image Max Width','_init','0000-00-00 00:00:00','2013-10-08 02:10:35'),
  (10,'portrait_height','720','Portrait Image Max Height','_init','0000-00-00 00:00:00','2013-10-08 02:10:37'),
  (11,'landscape_width','720','Landscape Image Max Width','_init','0000-00-00 00:00:00','2013-10-08 01:45:23'),
  (12,'landscape_height','540','Landscape Image Max Height','_init','0000-00-00 00:00:00','2013-10-08 01:45:23'),
  (13,'thumb_por_width','180','Thumbnail Portrait Image Max Width','_init','0000-00-00 00:00:00',NULL),
  (14,'thumb_por_height','260','Thumbnail Portrait Image Max Height','_init','0000-00-00 00:00:00',NULL),
  (15,'thumb_lan_width','260','Thumbnail Landscape Image Max Width','_init','0000-00-00 00:00:00',NULL),
  (16,'thumb_lan_height','180','Thumbnail Landscape Image Max Height','_init','0000-00-00 00:00:00',NULL);
COMMIT;

#
# Data for the user table  (LIMIT -495,500)
#

INSERT INTO user (id, first_name, last_name, phone, mobile, email, is_enable, is_admin, username, password, log_user, log_insert, log_update) VALUES

  (1,'Admin','Admin','111','111','admin@admin.com',1,1,'jmirancid','NoPa$$word001','DEV','2012-10-15 14:01:04','2013-09-07 11:58:52'),
  (3,'Felix','Ayala','111','111','foo@domain.com',1,0,'felix','NoPa$$word001','jmirancid',NULL,'2013-12-18 12:09:33'),
  (4,'Silvia','Ayala','111','111','foo@domain.com',1,0,'silvia','NoPa$$word001',NULL,NULL,'2013-09-07 12:19:30'),
  (5,'Elsa','Ayala','111','111','foo@domain.com',1,0,'elsa','NoPa$$word001',NULL,NULL,'2013-09-09 08:42:55');
COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;